How to: Open all related workbooks at once (create a Workspace).
Solution:
Create a Workspace file to open all related workbooks at once.
1) Open all workbooks to be included in the workspace.
2) (Optional) Arrange the workbook windows as they are to appear when the user opens them:
a) Select the 'Window' menu and select 'Arrange'.
b) Select one of the radio buttons to cascade or tile windows or to arrange them horizontally or vertically.
3) Select the 'File' menu and select 'Save Workspace...'.
4) Type a name for the workspace. (The default name is RESUME.XLW.)
CAUTION: Files contained in a workspace must not be moved from their location or Excel will be unable to locate them when the workspace is opened.
